Create Table Tb_Incident
(
  Incident_Number	Varchar2(15) not null,
Event_Source	Varchar2(255),
Category	Varchar2(255),
SUBCATEGORY	VARCHAR2(255),
Business_System_Type	Varchar2(255),
Busynesssystemid	Varchar2(255),
Description	Varchar2(100),
DETAILED_DECRIPTION	CLOB,
Impact	Varchar2(255),
Urgency	Varchar2(255),
Priority	Varchar2(255),
Employee_Number	Varchar2(50),
Customer_Department	Varchar2(50),
Customer_Email	Varchar2(50),
Customer_Name	Varchar2(50),
CUSTOMER_PHONE	VARCHAR2(50),
Assigned_Group	Varchar2(60),
Assigned_Group_Id	Varchar2(15),
Assignee	Varchar2(69),
ASSIGNEE_LOGIN_ID	VARCHAR2(254),
Resolution	Varchar2(4000),
Resolve_Code	Varchar2(255),
Resolved_By	Varchar2(254),
Resolved_Date	Date,
Status	Varchar2(255),
SUBMITTER	VARCHAR2(254),
Create_Date	Date,
Last_Modified_By	Varchar2(254),
Modified_Date	Date,
Closed_By	Varchar2(254),
Closed_Date	Date,
Sync_Date Date,
Update_Date Date,
Constraint Pk_Tb_Incident Primary Key(Incident_Number)
);

Create Table Tb_Incident_Temp
(
  Id	number(20) not null,
  Incident_Number	Varchar2(15),
Event_Source	Varchar2(255),
Category	Varchar2(255),
SUBCATEGORY	VARCHAR2(255),
Business_System_Type	Varchar2(255),
Busynesssystemid	Varchar2(255),
Description	Varchar2(100),
DETAILED_DECRIPTION	CLOB,
Impact	Varchar2(255),
Urgency	Varchar2(255),
Priority	Varchar2(255),
Employee_Number	Varchar2(50),
Customer_Department	Varchar2(50),
Customer_Email	Varchar2(50),
Customer_Name	Varchar2(50),
CUSTOMER_PHONE	VARCHAR2(50),
Assigned_Group	Varchar2(60),
Assigned_Group_Id	Varchar2(15),
Assignee	Varchar2(69),
ASSIGNEE_LOGIN_ID	VARCHAR2(254),
Resolution	Varchar2(4000),
Resolve_Code	Varchar2(255),
Resolved_By	Varchar2(254),
Resolved_Date	Date,
Status	Varchar2(255),
SUBMITTER	VARCHAR2(254),
Create_Date	Date,
Last_Modified_By	Varchar2(254),
Modified_Date	Date,
Closed_By	Varchar2(254),
Closed_Date	Date,
Sync_Date Date,
Update_Date Date,
Constraint Pk_Tb_Incident_Temp Primary Key(Id)
);

create sequence Tb_Incident_Temp_Seq;
